package com.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.*;

import java.io.Serializable;
import java.util.Date;


public class StudentExcel implements Serializable {
    // @ExcelProperty：用于设置表头和数据所在的列
    @ExcelProperty(value = "序号", index = 0)
    private Long id;
    // @ColumnWidth：设置单元格的宽度
    @ColumnWidth(value = 24)
    @ExcelProperty(value = "学院", index = 1)
    private String collegeName;

    @ColumnWidth(value = 24)
    @ExcelProperty(value = "专业", index = 2)
    private String majorName;

    @ColumnWidth(value = 24)
    @ExcelProperty(value = "班级", index = 3)
    private String className;

    @ColumnWidth(value = 24)
    @ExcelProperty(value = "学号", index = 4)
    private String number;

    @ColumnWidth(value = 30)
    @ExcelProperty(value = "身份证", index = 5)
    private String identity;

    @ColumnWidth(value = 20)
    @ExcelProperty(value = "报道日期", index = 6)
    private Date reportDate;

    @ColumnWidth(value = 24)
    @ExcelProperty(value = "照片", index = 7)
    private String photograph;

    @ExcelProperty(value = "状态", index = 8)
    private String state;

    public StudentExcel() {
    }

    public StudentExcel(Long id, String number, String identity, Date reportDate, String photograph, String state, String className, String majorName, String collegeName) {
        this.id = id;
        this.number = number;
        this.identity = identity;
        this.reportDate = reportDate;
        this.photograph = photograph;
        this.state = state;
        this.className = className;
        this.majorName = majorName;
        this.collegeName = collegeName;
    }

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getNumber() {
        return number;
    }

    public void setNumber(String number) {
        this.number = number;
    }

    public String getIdentity() {
        return identity;
    }

    public void setIdentity(String identity) {
        this.identity = identity;
    }

    public Date getReportDate() {
        return reportDate;
    }

    public void setReportDate(Date reportDate) {
        this.reportDate = reportDate;
    }

    public String getPhotograph() {
        return photograph;
    }

    public void setPhotograph(String photograph) {
        this.photograph = photograph;
    }

    public String getState() {
        return state;
    }

    public void setState(String state) {
        this.state = state;
    }

    public String getClassName() {
        return className;
    }

    public void setClassName(String className) {
        this.className = className;
    }

    public String getMajorName() {
        return majorName;
    }

    public void setMajorName(String majorName) {
        this.majorName = majorName;
    }

    public String getCollegeName() {
        return collegeName;
    }

    public void setCollegeName(String collegeName) {
        this.collegeName = collegeName;
    }

    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", number='" + number + '\'' +
                ", identity='" + identity + '\'' +
                ", reportDate=" + reportDate +
                ", photograph='" + photograph + '\'' +
                ", state='" + state + '\'' +
                ", className='" + className + '\'' +
                ", majorName='" + majorName + '\'' +
                ", collegeName='" + collegeName + '\'' +
                '}';
    }
}
